Upgrading external tables to SQL Server Compact Edition

Beginning with Meridian Enterprise 2010, the external databases (user accounts, Local Workspace, and lookup tables, if applicable) that are created and maintained by 64-bit components store the data in SQL Server Compact Edition instead of in Microsoft Access databases as in the previous versions. This is necessary because no 64-bit OLEDB driver for Microsoft Access is provided with Windows. When upgrading Meridian Enterprise from 32-bit to 64-bit components, these databases must be converted manually if no 64-bit OLEDB driver is installed. The upgrade will not overwrite the existing registry settings for Microsoft Access usage, they must be changed manually. The settings that must be changed are listed in Recommended server specifications.

We recommend that new Meridian Enterprise 64-bit installations use SQL Server Compact Edition and convert any existing Access databases using the following instructions. Existing installations may either install the 2010 Office System Driver and continue to maintain the databases in Microsoft Access format or convert existing Access databases to SQL Server Compact Edition using the following instructions.

Note The 64-bit Meridian Enterprise Configurator application cannot create tables in Microsoft Access format or add entries to the tables. Install and use the 32-bit Meridian Enterprise Configurator instead.

To convert the Microsoft Access databases to SQL Server Compact Edition:

• Use the program BlueCieloECM.MdbToSdfConvertor.exe located in the Meridian Enterprise Program folder.

To convert a lookup tables database:

• Run the following in the \BC-Meridian Extensions\<VaultName> folder:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe <VaultName>$LL.mdb -TTAB [-S[ql]]

To convert a user accounts database:

• Run the following in the \BC-Meridian Vaults folder:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe ICUserDB.mdb -TUDB [-S[ql]]

To convert a local workspace database:

• Run the following in the \BC-WorkSpace\<UserName>\<VaultContext>\__$$Environment folder:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe __$$Vault.mdb -TLWS -PAMSupport [-S[ql]]

To convert any other database:

• Run the following in the folder containing the database:

<PathToProgramFolder>\BlueCieloECM.MdbToSdfConvertor.exe <DBName>.mdb -TGEN [-P<DBPassword>] [-S[ql]]

Note     The optional [-S[ql]] parameter is for debugging or informational purposes only. It can be specified as -S or as -Sql and will display the output of the SQL statements that are executed.